StudentSubsidiaryAccountTransaction

EntityType | Independent
Logical Entity Name | StudentSubsidiaryAccountTransaction
Default Table Name | SaStudSubsidiaryTrans
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentSubsidiaryAccountTransaction Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
StudentSubsidiaryAccountTransactionId |  | INTEGER | NO |
TransactionNumber |  | SMALLINT | NO |
Description |  | VARCHAR(50) | NO |
BillingTransactionCode |  | VARCHAR(8) | NO |
StudentSubsidiaryAccountId |  | INTEGER | NO |
CampusId |  | INTEGER | YES |
BillingTransactionCodeId |  | INTEGER | YES |
TransactionDate |  | DATETIME | NO |
Reference |  | CHAR(23) | NO |
CheckNumber |  | VARCHAR(20) | YES |
BankAccountId |  | INTEGER | YES |
Amount |  | MONEY(19, 4) | NO |
AcademicYearSequence |  | SMALLINT | YES |
TermId |  | INTEGER | YES |
Type |  | CHAR(1) | NO |
IsPostedToGeneralLedger |  | BIT | NO |
StudentCreditCardId |  | INTEGER | YES |
BankDepositId |  | INTEGER | YES |
StudentRelationshipAddressId |  | INTEGER | YES |
StudentSubsidiaryAccountRefundId |  | INTEGER | YES |
PaymentType |  | CHAR(1) | YES |
ReceiptNumber |  | CHAR(16) | YES |
CreditCardAuthorizationNumber |  | CHAR(10) | YES |
CreditCardDeclineCode |  | CHAR(10) | YES |
CashDrawerSessionId |  | INTEGER | YES |
IsSentBack |  | BIT | NO |
Source |  | CHAR(1) | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
CheckStatus |  | CHAR(1) | NO |
CheckDate |  | DATETIME | YES |
EFTNumber |  | VARCHAR(20) | YES |
EFTStatus |  | CHAR(1) | YES |
EFTClearedDate |  | DATETIME | YES |
IsGeneralLedgerStatusFlag |  | BIT | NO |
IsInPendingQueue |  | BIT | NO |
OriginalSaStudSubsidiaryTransID |  | INTEGER | YES |
IsReIssue |  | BIT | NO |
CashDrawerSessionId |  | INTEGER | YES |
StudentCreditCardId |  | INTEGER | YES |

StudentSubsidiaryAccountTransaction Keys

Key Name | Key Type | Keys
SaStudSubsidiaryTrans_AdTermID_SaStudSubsidiaryTransID_U_N_IDX | Alternate Key | TermId, StudentSubsidiaryAccountTransactionId
SaStudSubsidiaryTrans_SaStudSubsidiaryID_SaStudSubsidiaryTransID_U_N_IDX | Alternate Key | StudentSubsidiaryAccountId, StudentSubsidiaryAccountTransactionId
SaStudSubsidiaryTrans_SaSubsidiaryRefundID_SaStudSubsidiaryTransID_U_N_IDX | Alternate Key | StudentSubsidiaryAccountRefundId, StudentSubsidiaryAccountTransactionId
SaStudSubsidiaryTrans_SaCCID_N_N_IDX | Inversion Entry | StudentCreditCardId
SaStudSubsidiaryTrans_SaCashDrawerSessionID_N_N_IDX | Inversion Entry | CashDrawerSessionId
SaStudSubsidiaryTrans_SaBillCodeID_N_N_IDX | Inversion Entry | BillingTransactionCodeId
SaStudSubsidiaryTrans_SaBankDepID_N_N_IDX | Inversion Entry | BankDepositId
SaStudSubsidiaryTrans_SaStudSubsidiaryTransID_U_C_IDX | PrimaryKey | StudentSubsidiaryAccountTransactionId
SaStudSubsidiaryTrans_SaBankAccountID_N_N_IDX | Inversion Entry | BankAccountId
SaStudSubsidiaryTrans_SyAddressID_N_N_IDX | Inversion Entry | StudentRelationshipAddressId
SaStudSubsidiaryTrans_UserID_SaStudSubsidiaryTransID_U_N_IDX | Alternate Key | LastModifiedUserId, StudentSubsidiaryAccountTransactionId
SaStudSubsidiaryTrans_SyCampusID_SaStudSubsidiaryTransID_U_N_IDX | Alternate Key | CampusId, StudentSubsidiaryAccountTransactionId

StudentSubsidiaryAccountTransaction Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
BankAccount | Non-Identifying | Zero or One to Zero or More |  |  |  | BankAccountId | NO
BankDeposit | Non-Identifying | Zero or One to Zero or More |  |  |  | BankDepositId | NO
BillingTransactionCode | Non-Identifying | Zero or One to Zero or More |  |  |  | BillingTransactionCodeId | NO
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | CampusId | NO
CashDrawerSession | Non-Identifying | Zero or One to Zero or More |  |  |  | CashDrawerSessionId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | TermId | NO
BankAccount | Non-Identifying | Zero or One to Zero or More |  |  |  | BankAccountId | NO
BankDeposit | Non-Identifying | Zero or One to Zero or More |  |  |  | BankDepositId | NO
BillingTransactionCode | Non-Identifying | Zero or One to Zero or More |  |  |  | BillingTransactionCodeId | NO
CashDrawerSession | Non-Identifying | Zero or One to Zero or More |  |  |  | CashDrawerSessionId | NO
StudentCreditCard | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentCreditCardId | NO
StudentSubsidiaryAccount | Non-Identifying | One To Zero or More |  |  |  | StudentSubsidiaryAccountId | NO
StudentSubsidiaryAccountRefund | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentSubsidiaryAccountRefundId | NO
StudentRelationshipAddress | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentRelationshipAddressId | NO
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | CampusId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO
StudentCreditCard | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentCreditCardId | NO
StudentRelationshipAddress | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentRelationshipAddressId | NO
StudentSubsidiaryAccount | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentSubsidiaryAccountId | NO
StudentSubsidiaryAccountRefund | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentSubsidiaryAccountRefundId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | TermId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
GeneralLedgerReleaseBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
GeneralLedgerReleaseBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentSubsidiaryAccountTransaction Check Constraints

Check Constraint Name | CheckConstraint

StudentSubsidiaryAccountTransaction Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentSubsidiaryAccountTransaction | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaStudSubsidiaryTrans | NO |  |  |

StudentSubsidiaryAccountTransaction Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Revenue_GL_BankDeposit
Logical | SubsidiaryLedger
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

StudentSubsidiaryAccountTransaction Data Movement Rules

Name | Type | Rule Text/Value